# 第三方模块  需要安装 才能使用
# 安装方式 pip 安装
# 配置 pip 清华源镜像
# python -m pip config set global.index-url https://pypi.tuna.tsinghua.edu.cn/simple

# 安装
# python -m pip install 模块名称   / python -m pip install 模块名称==版本号
# python -m pip list  查看已安装模块
# python -m pip uninstall 模块名称

# import pymysql
#
# db = pymysql.connect(
#     user='test',  # 用户名
#     password='test123',  # 密码
#     host='192.168.0.125',  # 数据库ip
#     port=3306,  # 数据库端口
#     database="wwt106_info",  # 数据库名称
#     charset='utf8mb4')  # 字符编码
#
# cs = db.cursor()
# text1 = "select * from stu;"
# text2 = "select * from question;"
# cs.execute(text1)
#
# data1 = cs.fetchall()
#
# print(data1)
#
# # 关闭连接
# db.close()

import openpyxl
file = openpyxl.load_workbook('lklk.xlsx')
data = file.worksheets[0]
data.append(('niday','niery','asug'))
data['B3'] = 'kkk'
file.save('lklk.xlsx')




# print(data)
#
# for i in data.values:
#     print(i)